﻿CREATE TABLE [dbo].[Measurement] (
    [MaterialID]            INT          NOT NULL,
    [QCAttribID]            INT          NOT NULL,
    [Value]                 NVARCHAR(50)          NOT NULL,
    [Date]                  DATE         NOT NULL,
    [Time]                  TIME (7)     NOT NULL,
    [EmpID]                 INT          NOT NULL,
    [Shift]                 INT          NOT NULL,
    [Crew]                  INT          NOT NULL,
    [Pass_Fail]             BIT          NOT NULL,
    [Target_ThresholdValue] DECIMAL (18) NOT NULL,
    [OnTime]                BIT          NOT NULL,
    [Delayed]               INT          NOT NULL
);

